Pandas Profiling Report

Dataset statistics

Number of variables	20
Number of observations	239677
Missing cells	0
Missing cells (%)	0.0%
Duplicate rows	0
Duplicate rows (%)	0.0%
Total size in memory	38.4 MiB
Average record size in memory	168.0 B

Variable types

Numeric	9
DateTime	1
Categorical	10

Alerts

`state` has a high cardinality: 51 distinct values	High cardinality
`city_or_county` has a high cardinality: 12898 distinct values	High cardinality
`address` has a high cardinality: 198037 distinct values	High cardinality
`gun_type` has a high cardinality: 2502 distinct values	High cardinality
`participant_age` has a high cardinality: 18951 distinct values	High cardinality
`participant_age_group` has a high cardinality: 898 distinct values	High cardinality
`participant_gender` has a high cardinality: 873 distinct values	High cardinality
`participant_relationship` has a high cardinality: 284 distinct values	High cardinality
`participant_status` has a high cardinality: 2150 distinct values	High cardinality
`participant_type` has a high cardinality: 259 distinct values	High cardinality
`incident_id` is highly correlated with `n_guns_involved`	High correlation
`n_guns_involved` is highly correlated with `incident_id`	High correlation
`state` is highly correlated with `congressional_district` and 4 other fields	High correlation
`n_killed` is highly correlated with `n_injured`	High correlation
`n_injured` is highly correlated with `n_killed`	High correlation
`congressional_district` is highly correlated with `state`	High correlation
`latitude` is highly correlated with `state` and 1 other fields	High correlation
`longitude` is highly correlated with `state` and 1 other fields	High correlation
`state_house_district` is highly correlated with `state`	High correlation
`state_senate_district` is highly correlated with `state`	High correlation
`n_killed` is highly skewed (γ1 = 55.55636018)	Skewed
`n_guns_involved` is highly skewed (γ1 = 67.45361155)	Skewed
`incident_id` has unique values	Unique
`latitude` has 7923 (3.3%) zeros	Zeros
`longitude` has 7923 (3.3%) zeros	Zeros

Reproduction

Analysis started	2022-10-13 12:44:22.885844
Analysis finished	2022-10-13 12:45:21.400613
Duration	58.51 seconds
Software version	pandas-profiling v3.3.0
Download configuration	config.json

incident_id
Real number (ℝ_≥0)

HIGH CORRELATION
UNIQUE

Distinct	239677
Distinct (%)	100.0%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	559334.3464

Minimum	92114
Maximum	1083472
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	3.7 MiB

Quantile statistics

Minimum	92114
5-th percentile	126858.6
Q1	308545
median	543587
Q3	817228
95-th percentile	1028801.6
Maximum	1083472
Range	991358
Interquartile range (IQR)	508683

Descriptive statistics

Standard deviation	293128.6843
Coefficient of variation (CV)	0.5240670203
Kurtosis	-1.22417132
Mean	559334.3464
Median Absolute Deviation (MAD)	253242
Skewness	0.09516790421
Sum	1.340595781 × 10¹¹
Variance	8.592442555 × 10¹⁰
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
461105	1	< 0.1%
717982	1	< 0.1%
718485	1	< 0.1%
718520	1	< 0.1%
719602	1	< 0.1%
718791	1	< 0.1%
717783	1	< 0.1%
717393	1	< 0.1%
717685	1	< 0.1%
719638	1	< 0.1%
Other values (239667)	239667	> 99.9%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
92114	1	< 0.1%
92117	1	< 0.1%
92119	1	< 0.1%
92122	1	< 0.1%
92125	1	< 0.1%
92129	1	< 0.1%
92131	1	< 0.1%
92133	1	< 0.1%
92135	1	< 0.1%
92137	1	< 0.1%

Value	Count	Frequency (%)
1083472	1	< 0.1%
1083466	1	< 0.1%
1083457	1	< 0.1%
1083435	1	< 0.1%
1083428	1	< 0.1%
1083413	1	< 0.1%
1083396	1	< 0.1%
1083390	1	< 0.1%
1083389	1	< 0.1%
1083379	1	< 0.1%

date
Date

Distinct	1725
Distinct (%)	0.7%
Missing	0
Missing (%)	0.0%
Memory size	3.7 MiB

Minimum	2013-01-01 00:00:00
Maximum	2018-12-03 00:00:00

Histogram

Histogram with fixed size bins (bins=50)

state
Categorical

HIGH CARDINALITY
HIGH CORRELATION

Distinct	51
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	3.7 MiB

Illinois	17556
California	16306
Florida	15029
Texas	13577
Ohio	10244
Other values (46)	166965

Length

Max length	20
Median length	13
Mean length	8.664310718
Min length	4

Characters and Unicode

Total characters	2076636
Distinct characters	46
Distinct categories	3 ?
Distinct scripts	2 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	Pennsylvania
2nd row	California
3rd row	Ohio
4th row	Colorado
5th row	North Carolina

Common Values

Value	Count	Frequency (%)
Illinois	17556	7.3%
California	16306	6.8%
Florida	15029	6.3%
Texas	13577	5.7%
Ohio	10244	4.3%
New York	9712	4.1%
Pennsylvania	8929	3.7%
Georgia	8925	3.7%
North Carolina	8739	3.6%
Louisiana	8103	3.4%
Other values (41)	122557	51.1%

Length

Histogram of lengths of the category

Value	Count	Frequency (%)
new	17708	6.3%
illinois	17556	6.2%
california	16306	5.8%
carolina	15678	5.5%
florida	15029	5.3%
texas	13577	4.8%
ohio	10244	3.6%
york	9712	3.4%
north	9312	3.3%
pennsylvania	8929	3.2%
Other values (45)	148989	52.6%

Most occurring characters

Value	Count	Frequency (%)
a	256726	12.4%
i	246073	11.8%
n	176038	8.5%
o	171176	8.2%
s	155405	7.5%
e	121747	5.9%
r	118926	5.7%
l	116103	5.6%
t	56154	2.7%
h	49637	2.4%
Other values (36)	608651	29.3%

Most occurring categories

Value	Count	Frequency (%)
Lowercase Letter	1753428	84.4%
Uppercase Letter	279845	13.5%
Space Separator	43363	2.1%

Most frequent character per category

Lowercase Letter

Value	Count	Frequency (%)
a	256726	14.6%
i	246073	14.0%
n	176038	10.0%
o	171176	9.8%
s	155405	8.9%
e	121747	6.9%
r	118926	6.8%
l	116103	6.6%
t	56154	3.2%
h	49637	2.8%
Other values (14)	285443	16.3%

Uppercase Letter

Value	Count	Frequency (%)
C	41447	14.8%
M	33743	12.1%
N	30623	10.9%
I	27481	9.8%
T	21203	7.6%
O	15985	5.7%
F	15029	5.4%
A	11990	4.3%
W	10290	3.7%
Y	9712	3.5%
Other values (11)	62342	22.3%

Space Separator

Value	Count	Frequency (%)
	43363	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Latin	2033273	97.9%
Common	43363	2.1%

Most frequent character per script

Latin

Value	Count	Frequency (%)
a	256726	12.6%
i	246073	12.1%
n	176038	8.7%
o	171176	8.4%
s	155405	7.6%
e	121747	6.0%
r	118926	5.8%
l	116103	5.7%
t	56154	2.8%
h	49637	2.4%
Other values (35)	565288	27.8%

Common

Value	Count	Frequency (%)
	43363	100.0%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	2076636	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
a	256726	12.4%
i	246073	11.8%
n	176038	8.5%
o	171176	8.2%
s	155405	7.5%
e	121747	5.9%
r	118926	5.7%
l	116103	5.6%
t	56154	2.7%
h	49637	2.4%
Other values (36)	608651	29.3%

city_or_county
Categorical

HIGH CARDINALITY

Distinct	12898
Distinct (%)	5.4%
Missing	0
Missing (%)	0.0%
Memory size	3.7 MiB

Chicago	10814
Baltimore	3943
Washington	3279
New Orleans	3071
Philadelphia	2963
Other values (12893)	215607

Length

Max length	46
Median length	43
Mean length	9.355365763
Min length	3

Characters and Unicode

Total characters	2242266
Distinct characters	59
Distinct categories	7 ?
Distinct scripts	2 ?
Distinct blocks	2 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	5031 ?
Unique (%)	2.1%

Sample

1st row	Mckeesport
2nd row	Hawthorne
3rd row	Lorain
4th row	Aurora
5th row	Greensboro

Common Values

Value	Count	Frequency (%)
Chicago	10814	4.5%
Baltimore	3943	1.6%
Washington	3279	1.4%
New Orleans	3071	1.3%
Philadelphia	2963	1.2%
Saint Louis	2501	1.0%
Houston	2501	1.0%
Milwaukee	2487	1.0%
Jacksonville	2448	1.0%
Memphis	2386	1.0%
Other values (12888)	203284	84.8%

Length

Histogram of lengths of the category

Value	Count	Frequency (%)
chicago	11796	3.8%
city	6413	2.1%
county	6348	2.0%
new	5148	1.7%
saint	4315	1.4%
baltimore	3966	1.3%
washington	3401	1.1%
san	3353	1.1%
orleans	3157	1.0%
beach	2994	1.0%
Other values (8671)	258802	83.6%

Most occurring characters

Value	Count	Frequency (%)
a	200004	8.9%
o	181617	8.1%
e	181294	8.1%
n	168763	7.5%
i	152407	6.8%
l	137985	6.2%
t	123954	5.5%
r	117309	5.2%
s	98636	4.4%
	70150	3.1%
Other values (49)	810147	36.1%

Most occurring categories

Value	Count	Frequency (%)
Lowercase Letter	1842443	82.2%
Uppercase Letter	306110	13.7%
Space Separator	70150	3.1%
Close Punctuation	11462	0.5%
Open Punctuation	11462	0.5%
Dash Punctuation	512	< 0.1%
Other Punctuation	127	< 0.1%

Most frequent character per category

Lowercase Letter

Value	Count	Frequency (%)
a	200004	10.9%
o	181617	9.9%
e	181294	9.8%
n	168763	9.2%
i	152407	8.3%
l	137985	7.5%
t	123954	6.7%
r	117309	6.4%
s	98636	5.4%
h	62169	3.4%
Other values (17)	418305	22.7%

Uppercase Letter

Value	Count	Frequency (%)
C	44556	14.6%
S	27436	9.0%
B	26681	8.7%
M	21634	7.1%
L	20173	6.6%
P	19538	6.4%
A	15128	4.9%
W	14652	4.8%
H	14198	4.6%
R	12615	4.1%
Other values (16)	89499	29.2%

Other Punctuation

Value	Count	Frequency (%)
'	74	58.3%
.	53	41.7%

Space Separator

Value	Count	Frequency (%)
	70150	100.0%

Close Punctuation

Value	Count	Frequency (%)
)	11462	100.0%

Open Punctuation

Value	Count	Frequency (%)
(	11462	100.0%

Dash Punctuation

Value	Count	Frequency (%)
-	512	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Latin	2148553	95.8%
Common	93713	4.2%

Most frequent character per script

Latin

Value	Count	Frequency (%)
a	200004	9.3%
o	181617	8.5%
e	181294	8.4%
n	168763	7.9%
i	152407	7.1%
l	137985	6.4%
t	123954	5.8%
r	117309	5.5%
s	98636	4.6%
h	62169	2.9%
Other values (43)	724415	33.7%

Common

Value	Count	Frequency (%)
	70150	74.9%
)	11462	12.2%
(	11462	12.2%
-	512	0.5%
'	74	0.1%
.	53	0.1%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	2242261	> 99.9%
None	5	< 0.1%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
a	200004	8.9%
o	181617	8.1%
e	181294	8.1%
n	168763	7.5%
i	152407	6.8%
l	137985	6.2%
t	123954	5.5%
r	117309	5.2%
s	98636	4.4%
	70150	3.1%
Other values (48)	810142	36.1%

None

Value	Count	Frequency (%)
ñ	5	100.0%

address
Categorical

HIGH CARDINALITY

Distinct	198037
Distinct (%)	82.6%
Missing	0
Missing (%)	0.0%
Memory size	3.7 MiB

2375 International Pkwy	16657
6000 N Terminal Pkwy	141
Main Street	131
3400 E Sky Harbor Blvd	127
8500 Peña Blvd	99
Other values (198032)	222522

Length

Max length	97
Median length	75
Mean length	22.50227181
Min length	2

Characters and Unicode

Total characters	5393277
Distinct characters	93
Distinct categories	15 ?
Distinct scripts	2 ?
Distinct blocks	4 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	184863 ?
Unique (%)	77.1%

Sample

1st row	1506 Versailles Avenue and Coursin Street
2nd row	13500 block of Cerise Avenue
3rd row	1776 East 28th Street
4th row	16000 block of East Ithaca Place
5th row	307 Mourning Dove Terrace

Common Values

Value	Count	Frequency (%)
2375 International Pkwy	16657	6.9%
6000 N Terminal Pkwy	141	0.1%
Main Street	131	0.1%
3400 E Sky Harbor Blvd	127	0.1%
8500 Peña Blvd	99	< 0.1%
2800 N Terminal Rd	86	< 0.1%
6000 North Terminal Parkway	80	< 0.1%
1 Terminal Dr	62	< 0.1%
1 Jeff Fuqua Blvd	61	< 0.1%
3200 E Airfield Dr	57	< 0.1%
Other values (198027)	222176	92.7%

Length

Histogram of lengths of the category

Value	Count	Frequency (%)
block	83046	8.3%
of	82994	8.3%
street	47009	4.7%
and	34826	3.5%
avenue	32127	3.2%
st	31940	3.2%
ave	21322	2.1%
road	20226	2.0%
pkwy	17627	1.8%
international	17395	1.7%
Other values (39852)	616856	61.4%

Most occurring characters

Value	Count	Frequency (%)
	771361	14.3%
e	406615	7.5%
o	350182	6.5%
t	315058	5.8%
a	261923	4.9%
n	256455	4.8%
r	240715	4.5%
0	234554	4.3%
l	215068	4.0%
i	137799	2.6%
Other values (83)	2203547	40.9%

Most occurring categories

Value	Count	Frequency (%)
Lowercase Letter	3286464	60.9%
Space Separator	771363	14.3%
Decimal Number	690325	12.8%
Uppercase Letter	622518	11.5%
Other Punctuation	19718	0.4%
Dash Punctuation	2721	0.1%
Final Punctuation	106	< 0.1%
Open Punctuation	21	< 0.1%
Close Punctuation	20	< 0.1%
Other Number	12	< 0.1%
Other values (5)	9	< 0.1%

Most frequent character per category

Lowercase Letter

Value	Count	Frequency (%)
e	406615	12.4%
o	350182	10.7%
t	315058	9.6%
a	261923	8.0%
n	256455	7.8%
r	240715	7.3%
l	215068	6.5%
i	137799	4.2%
d	133862	4.1%
k	125391	3.8%
Other values (19)	843396	25.7%

Uppercase Letter

Value	Count	Frequency (%)
S	125002	20.1%
A	67805	10.9%
R	45933	7.4%
P	39020	6.3%
W	36913	5.9%
C	34134	5.5%
B	32824	5.3%
D	30559	4.9%
N	29319	4.7%
E	27076	4.3%
Other values (16)	153933	24.7%

Decimal Number

Value	Count	Frequency (%)
0	234554	34.0%
1	89284	12.9%
2	75558	10.9%
3	62760	9.1%
5	58332	8.4%
7	46499	6.7%
4	40154	5.8%
6	31171	4.5%
8	26838	3.9%
9	25175	3.6%

Other Punctuation

Value	Count	Frequency (%)
.	18286	92.7%
,	582	3.0%
'	314	1.6%
/	281	1.4%
#	124	0.6%
&	106	0.5%
;	18	0.1%
"	6	< 0.1%
\	1	< 0.1%

Format

Value	Count	Frequency (%)
	2	40.0%
‎	1	20.0%
	1	20.0%
	1	20.0%

Space Separator

Value	Count	Frequency (%)
	771361	> 99.9%
	2	< 0.1%

Dash Punctuation

Value	Count	Frequency (%)
-	2720	> 99.9%
–	1	< 0.1%

Open Punctuation

Value	Count	Frequency (%)
(	20	95.2%
[	1	4.8%

Close Punctuation

Value	Count	Frequency (%)
)	19	95.0%
]	1	5.0%

Other Number

Value	Count	Frequency (%)
½	11	91.7%
¼	1	8.3%

Final Punctuation

Value	Count	Frequency (%)
’	106	100.0%

Modifier Letter

Value	Count	Frequency (%)
ʻ	1	100.0%

Line Separator

Value	Count	Frequency (%)
	1	100.0%

Modifier Symbol

Value	Count	Frequency (%)
`	1	100.0%

Initial Punctuation

Value	Count	Frequency (%)
‘	1	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Latin	3908982	72.5%
Common	1484295	27.5%

Most frequent character per script

Latin

Value	Count	Frequency (%)
e	406615	10.4%
o	350182	9.0%
t	315058	8.1%
a	261923	6.7%
n	256455	6.6%
r	240715	6.2%
l	215068	5.5%
i	137799	3.5%
d	133862	3.4%
k	125391	3.2%
Other values (45)	1465914	37.5%

Common

Value	Count	Frequency (%)
	771361	52.0%
0	234554	15.8%
1	89284	6.0%
2	75558	5.1%
3	62760	4.2%
5	58332	3.9%
7	46499	3.1%
4	40154	2.7%
6	31171	2.1%
8	26838	1.8%
Other values (28)	47784	3.2%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	5393020	> 99.9%
None	145	< 0.1%
Punctuation	111	< 0.1%
Modifier Letters	1	< 0.1%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
	771361	14.3%
e	406615	7.5%
o	350182	6.5%
t	315058	5.8%
a	261923	4.9%
n	256455	4.8%
r	240715	4.5%
0	234554	4.3%
l	215068	4.0%
i	137799	2.6%
Other values (68)	2203290	40.9%

None

Value	Count	Frequency (%)
ñ	126	86.9%
½	11	7.6%
	2	1.4%
	2	1.4%
é	1	0.7%
¼	1	0.7%
	1	0.7%
í	1	0.7%

Punctuation

Value	Count	Frequency (%)
’	106	95.5%
‎	1	0.9%
–	1	0.9%
	1	0.9%
‘	1	0.9%
	1	0.9%

Modifier Letters

Value	Count	Frequency (%)
ʻ	1	100.0%

n_killed
Real number (ℝ_≥0)

HIGH CORRELATION
SKEWED

Distinct	16
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	1.123063779

Minimum	1
Maximum	50
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	3.7 MiB

Quantile statistics

Minimum	1
5-th percentile	1
Q1	1.123063779
median	1.123063779
Q3	1.123063779
95-th percentile	1.123063779
Maximum	50
Range	49
Interquartile range (IQR)	0

Descriptive statistics

Standard deviation	0.2292706777
Coefficient of variation (CV)	0.2041475132
Kurtosis	9576.758969
Mean	1.123063779
Median Absolute Deviation (MAD)	0
Skewness	55.55636018
Sum	269172.5574
Variance	0.05256504364
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=16)

Value	Count	Frequency (%)
1.123063779	185835	77.5%
1	48436	20.2%
2	4604	1.9%
3	595	0.2%
4	139	0.1%
5	41	< 0.1%
6	11	< 0.1%
8	5	< 0.1%
9	3	< 0.1%
7	2	< 0.1%
Other values (6)	6	< 0.1%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
1	48436	20.2%
1.123063779	185835	77.5%
2	4604	1.9%
3	595	0.2%
4	139	0.1%
5	41	< 0.1%
6	11	< 0.1%
7	2	< 0.1%
8	5	< 0.1%
9	3	< 0.1%

Value	Count	Frequency (%)
50	1	< 0.1%
27	1	< 0.1%
17	1	< 0.1%
16	1	< 0.1%
11	1	< 0.1%
10	1	< 0.1%
9	3	< 0.1%
8	5	< 0.1%
7	2	< 0.1%
6	11	< 0.1%

n_injured
Real number (ℝ_≥0)

HIGH CORRELATION

Distinct	23
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	1.218252907

Minimum	1
Maximum	53
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	3.7 MiB

Quantile statistics

Minimum	1
5-th percentile	1
Q1	1
median	1.218252907
Q3	1.218252907
95-th percentile	2
Maximum	53
Range	52
Interquartile range (IQR)	0.2182529067

Descriptive statistics

Standard deviation	0.4183854601
Coefficient of variation (CV)	0.3434307095
Kurtosis	1205.739971
Mean	1.218252907
Median Absolute Deviation (MAD)	0
Skewness	17.27966916
Sum	291987.2019
Variance	0.1750463932
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=23)

Value	Count	Frequency (%)
1.218252907	142487	59.4%
1	81986	34.2%
2	11484	4.8%
3	2513	1.0%
4	760	0.3%
5	241	0.1%
6	91	< 0.1%
7	51	< 0.1%
8	19	< 0.1%
9	12	< 0.1%
Other values (13)	33	< 0.1%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
1	81986	34.2%
1.218252907	142487	59.4%
2	11484	4.8%
3	2513	1.0%
4	760	0.3%
5	241	0.1%
6	91	< 0.1%
7	51	< 0.1%
8	19	< 0.1%
9	12	< 0.1%

Value	Count	Frequency (%)
53	1	< 0.1%
25	1	< 0.1%
20	1	< 0.1%
19	3	< 0.1%
18	1	< 0.1%
17	2	< 0.1%
16	2	< 0.1%
15	2	< 0.1%
14	3	< 0.1%
13	2	< 0.1%

congressional_district
Real number (ℝ_≥0)

HIGH CORRELATION

Distinct	54
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	8.016083621

Minimum	1
Maximum	53
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	3.7 MiB

Quantile statistics

Minimum	1
5-th percentile	1
Q1	2
median	6
Q3	10
95-th percentile	26
Maximum	53
Range	52
Interquartile range (IQR)	8

Descriptive statistics

Standard deviation	8.260000743
Coefficient of variation (CV)	1.030428465
Kurtosis	5.609405356
Mean	8.016083621
Median Absolute Deviation (MAD)	4
Skewness	2.162460651
Sum	1921270.874
Variance	68.22761227
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
1	36910	15.4%
2	26945	11.2%
3	20621	8.6%
7	19709	8.2%
4	18469	7.7%
5	16512	6.9%
8.016083621	12365	5.2%
9	9867	4.1%
6	9388	3.9%
8	7353	3.1%
Other values (44)	61538	25.7%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
1	36910	15.4%
2	26945	11.2%
3	20621	8.6%
4	18469	7.7%
5	16512	6.9%
6	9388	3.9%
7	19709	8.2%
8	7353	3.1%
8.016083621	12365	5.2%
9	9867	4.1%

Value	Count	Frequency (%)
53	130	0.1%
52	158	0.1%
51	228	0.1%
50	116	< 0.1%
49	100	< 0.1%
48	119	< 0.1%
47	292	0.1%
46	251	0.1%
45	45	< 0.1%
44	421	0.2%

gun_type
Categorical

HIGH CARDINALITY

Distinct	2502
Distinct (%)	1.0%
Missing	0
Missing (%)	0.0%
Memory size	3.7 MiB

0::Unknown	193010
0::Handgun	13018
0::9mm	4599
0::Unknown\|\|1::Unknown	2410
0::22 LR	2193
Other values (2497)	24447

Length

Max length	5488
Median length	10
Mean length	12.59401194
Min length	5

Characters and Unicode

Total characters	3018495
Distinct characters	44
Distinct categories	9 ?
Distinct scripts	2 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	1867 ?
Unique (%)	0.8%

Sample

1st row	0::Unknown
2nd row	0::Unknown
3rd row	0::Unknown\|\|1::Unknown
4th row	0::Unknown
5th row	0::Handgun\|\|1::Handgun

Common Values

Value	Count	Frequency (%)
0::Unknown	193010	80.5%
0::Handgun	13018	5.4%
0::9mm	4599	1.9%
0::Unknown\|\|1::Unknown	2410	1.0%
0::22 LR	2193	0.9%
0::Shotgun	2151	0.9%
0::40 SW	1947	0.8%
0::380 Auto	1844	0.8%
0::45 Auto	1537	0.6%
0::Rifle	1522	0.6%
Other values (2492)	15446	6.4%

Length

Histogram of lengths of the category

Value	Count	Frequency (%)
0::unknown	193010	74.1%
0::handgun	13018	5.0%
auto	4773	1.8%
0::9mm	4599	1.8%
0::22	2602	1.0%
lr	2558	1.0%
0::unknown\|\|1::unknown	2410	0.9%
0::40	2240	0.9%
sw	2217	0.9%
0::shotgun	2151	0.8%
Other values (2722)	30842	11.8%

Most occurring characters

Value	Count	Frequency (%)
n	746412	24.7%
:	583401	19.3%
0	248967	8.2%
o	240744	8.0%
U	230605	7.6%
k	230605	7.6%
w	230605	7.6%
\|	104403	3.5%
u	36648	1.2%
g	33261	1.1%
Other values (34)	332844	11.0%

Most occurring categories

Value	Count	Frequency (%)
Lowercase Letter	1632333	54.1%
Other Punctuation	584341	19.4%
Decimal Number	374616	12.4%
Uppercase Letter	294206	9.7%
Math Symbol	104403	3.5%
Space Separator	20743	0.7%
Dash Punctuation	2747	0.1%
Open Punctuation	2553	0.1%
Close Punctuation	2553	0.1%

Most frequent character per category

Lowercase Letter

Value	Count	Frequency (%)
n	746412	45.7%
o	240744	14.7%
k	230605	14.1%
w	230605	14.1%
u	36648	2.2%
g	33261	2.0%
a	27531	1.7%
d	25050	1.5%
m	14635	0.9%
t	11204	0.7%
Other values (7)	35638	2.2%

Decimal Number

Value	Count	Frequency (%)
0	248967	66.5%
1	28495	7.6%
2	26517	7.1%
3	16236	4.3%
4	12728	3.4%
5	10539	2.8%
9	10164	2.7%
8	8254	2.2%
7	6965	1.9%
6	5751	1.5%

Uppercase Letter

Value	Count	Frequency (%)
U	230605	78.4%
H	25050	8.5%
R	11855	4.0%
S	8915	3.0%
A	8421	2.9%
L	3358	1.1%
W	2975	1.0%
O	1065	0.4%
M	1022	0.3%
K	940	0.3%

Other Punctuation

Value	Count	Frequency (%)
:	583401	99.8%
.	940	0.2%

Math Symbol

Value	Count	Frequency (%)
\|	104403	100.0%

Space Separator

Value	Count	Frequency (%)
	20743	100.0%

Dash Punctuation

Value	Count	Frequency (%)
-	2747	100.0%

Open Punctuation

Value	Count	Frequency (%)
[	2553	100.0%

Close Punctuation

Value	Count	Frequency (%)
]	2553	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Latin	1926539	63.8%
Common	1091956	36.2%

Most frequent character per script

Latin

Value	Count	Frequency (%)
n	746412	38.7%
o	240744	12.5%
U	230605	12.0%
k	230605	12.0%
w	230605	12.0%
u	36648	1.9%
g	33261	1.7%
a	27531	1.4%
d	25050	1.3%
H	25050	1.3%
Other values (17)	100028	5.2%

Common

Value	Count	Frequency (%)
:	583401	53.4%
0	248967	22.8%
\|	104403	9.6%
1	28495	2.6%
2	26517	2.4%
	20743	1.9%
3	16236	1.5%
4	12728	1.2%
5	10539	1.0%
9	10164	0.9%
Other values (7)	29763	2.7%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	3018495	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
n	746412	24.7%
:	583401	19.3%
0	248967	8.2%
o	240744	8.0%
U	230605	7.6%
k	230605	7.6%
w	230605	7.6%
\|	104403	3.5%
u	36648	1.2%
g	33261	1.1%
Other values (34)	332844	11.0%

latitude
Real number (ℝ_≥0)

HIGH CORRELATION
ZEROS

Distinct	101241
Distinct (%)	42.2%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	36.30542073

Minimum	0
Maximum	71.3368
Zeros	7923
Zeros (%)	3.3%
Negative	0
Negative (%)	0.0%
Memory size	3.7 MiB

Quantile statistics

Minimum	0
5-th percentile	26.66574
Q1	33.5778
median	38.1818
Q3	41.2851
95-th percentile	43.9448
Maximum	71.3368
Range	71.3368
Interquartile range (IQR)	7.7073

Descriptive statistics

Standard deviation	8.397390649
Coefficient of variation (CV)	0.2312985356
Kurtosis	9.282299171
Mean	36.30542073
Median Absolute Deviation (MAD)	3.6093
Skewness	-2.462578632
Sum	8701574.325
Variance	70.51616971
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0	7923	3.3%
33.6356	253	0.1%
39.294	244	0.1%
29.9872	170	0.1%
33.4347	161	0.1%
32.8982	160	0.1%
38.9075	142	0.1%
36.1334	112	< 0.1%
29.9551	109	< 0.1%
28.436	109	< 0.1%
Other values (101231)	230294	96.1%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0	7923	3.3%
19.1114	1	< 0.1%
19.1127	1	< 0.1%
19.2	1	< 0.1%
19.2017	1	< 0.1%
19.4243	1	< 0.1%
19.4331	1	< 0.1%
19.4475	1	< 0.1%
19.4554	1	< 0.1%
19.4578	1	< 0.1%

Value	Count	Frequency (%)
71.3368	1	< 0.1%
71.3005	1	< 0.1%
71.3001	1	< 0.1%
71.3	1	< 0.1%
71.2997	1	< 0.1%
71.2921	1	< 0.1%
71.2906	1	< 0.1%
70.6698	1	< 0.1%
70.1981	1	< 0.1%
67.5533	1	< 0.1%

longitude
Real number (ℝ_≥0)

HIGH CORRELATION
ZEROS

Distinct	101241
Distinct (%)	42.2%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	36.30542073

Minimum	0
Maximum	71.3368
Zeros	7923
Zeros (%)	3.3%
Negative	0
Negative (%)	0.0%
Memory size	3.7 MiB

Quantile statistics

Minimum	0
5-th percentile	26.66574
Q1	33.5778
median	38.1818
Q3	41.2851
95-th percentile	43.9448
Maximum	71.3368
Range	71.3368
Interquartile range (IQR)	7.7073

Descriptive statistics

Standard deviation	8.397390649
Coefficient of variation (CV)	0.2312985356
Kurtosis	9.282299171
Mean	36.30542073
Median Absolute Deviation (MAD)	3.6093
Skewness	-2.462578632
Sum	8701574.325
Variance	70.51616971
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0	7923	3.3%
33.6356	253	0.1%
39.294	244	0.1%
29.9872	170	0.1%
33.4347	161	0.1%
32.8982	160	0.1%
38.9075	142	0.1%
36.1334	112	< 0.1%
29.9551	109	< 0.1%
28.436	109	< 0.1%
Other values (101231)	230294	96.1%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0	7923	3.3%
19.1114	1	< 0.1%
19.1127	1	< 0.1%
19.2	1	< 0.1%
19.2017	1	< 0.1%
19.4243	1	< 0.1%
19.4331	1	< 0.1%
19.4475	1	< 0.1%
19.4554	1	< 0.1%
19.4578	1	< 0.1%

Value	Count	Frequency (%)
71.3368	1	< 0.1%
71.3005	1	< 0.1%
71.3001	1	< 0.1%
71.3	1	< 0.1%
71.2997	1	< 0.1%
71.2921	1	< 0.1%
71.2906	1	< 0.1%
70.6698	1	< 0.1%
70.1981	1	< 0.1%
67.5533	1	< 0.1%

n_guns_involved
Real number (ℝ_≥0)

HIGH CORRELATION
SKEWED

Distinct	107
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	1.37244163

Minimum	1
Maximum	400
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	3.7 MiB

Quantile statistics

Minimum	1
5-th percentile	1
Q1	1
median	1
Q3	1.37244163
95-th percentile	2
Maximum	400
Range	399
Interquartile range (IQR)	0.3724416299

Descriptive statistics

Standard deviation	3.578322166
Coefficient of variation (CV)	2.607267288
Kurtosis	6111.509851
Mean	1.37244163
Median Absolute Deviation (MAD)	0
Skewness	67.45361155
Sum	328942.6925
Variance	12.80438952
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
1	127548	53.2%
1.37244163	99451	41.5%
2	7477	3.1%
3	2021	0.8%
4	871	0.4%
5	435	0.2%
6	285	0.1%
7	232	0.1%
8	137	0.1%
9	111	< 0.1%
Other values (97)	1109	0.5%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
1	127548	53.2%
1.37244163	99451	41.5%
2	7477	3.1%
3	2021	0.8%
4	871	0.4%
5	435	0.2%
6	285	0.1%
7	232	0.1%
8	137	0.1%
9	111	< 0.1%

Value	Count	Frequency (%)
400	4	< 0.1%
399	1	< 0.1%
374	1	< 0.1%
346	1	< 0.1%
338	1	< 0.1%
323	1	< 0.1%
300	3	< 0.1%
280	1	< 0.1%
276	1	< 0.1%
268	1	< 0.1%

participant_age
Categorical

HIGH CARDINALITY

Distinct	18951
Distinct (%)	7.9%
Missing	0
Missing (%)	0.0%
Memory size	3.7 MiB

0::24	96112
0::23	3735
0::22	3733
0::19	3719
0::21	3612
Other values (18946)	128766

Length

Max length	517
Median length	5
Mean length	7.142466736
Min length	4

Characters and Unicode

Total characters	1711885
Distinct characters	13
Distinct categories	3 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	13962 ?
Unique (%)	5.8%

Sample

1st row	0::20
2nd row	0::20
3rd row	0::25\|\|1::31\|\|2::33\|\|3::34\|\|4::33
4th row	0::29\|\|1::33\|\|2::56\|\|3::33
5th row	0::18\|\|1::46\|\|2::14\|\|3::47

Common Values

Value	Count	Frequency (%)
0::24	96112	40.1%
0::23	3735	1.6%
0::22	3733	1.6%
0::19	3719	1.6%
0::21	3612	1.5%
0::18	3536	1.5%
0::20	3535	1.5%
0::25	3500	1.5%
0::26	3277	1.4%
0::27	3110	1.3%
Other values (18941)	111808	46.6%

Length

Histogram of lengths of the category

Value	Count	Frequency (%)
0::24	96112	40.1%
0::23	3735	1.6%
0::22	3733	1.6%
0::19	3719	1.6%
0::21	3612	1.5%
0::18	3536	1.5%
0::20	3535	1.5%
0::25	3500	1.5%
0::26	3277	1.4%
0::27	3110	1.3%
Other values (18941)	111808	46.6%

Most occurring characters

Value	Count	Frequency (%)
:	624586	36.5%
0	247809	14.5%
2	221435	12.9%
\|	147354	8.6%
4	136589	8.0%
1	124641	7.3%
3	71904	4.2%
5	34462	2.0%
6	27289	1.6%
8	25757	1.5%
Other values (3)	50059	2.9%

Most occurring categories

Value	Count	Frequency (%)
Decimal Number	939886	54.9%
Other Punctuation	624645	36.5%
Math Symbol	147354	8.6%

Most frequent character per category

Decimal Number

Value	Count	Frequency (%)
0	247809	26.4%
2	221435	23.6%
4	136589	14.5%
1	124641	13.3%
3	71904	7.7%
5	34462	3.7%
6	27289	2.9%
8	25757	2.7%
7	25657	2.7%
9	24343	2.6%

Other Punctuation

Value	Count	Frequency (%)
:	624586	> 99.9%
.	59	< 0.1%

Math Symbol

Value	Count	Frequency (%)
\|	147354	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Common	1711885	100.0%

Most frequent character per script

Common

Value	Count	Frequency (%)
:	624586	36.5%
0	247809	14.5%
2	221435	12.9%
\|	147354	8.6%
4	136589	8.0%
1	124641	7.3%
3	71904	4.2%
5	34462	2.0%
6	27289	1.6%
8	25757	1.5%
Other values (3)	50059	2.9%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	1711885	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
:	624586	36.5%
0	247809	14.5%
2	221435	12.9%
\|	147354	8.6%
4	136589	8.0%
1	124641	7.3%
3	71904	4.2%
5	34462	2.0%
6	27289	1.6%
8	25757	1.5%
Other values (3)	50059	2.9%

participant_age_group
Categorical

HIGH CARDINALITY

Distinct	898
Distinct (%)	0.4%
Missing	0
Missing (%)	0.0%
Memory size	3.7 MiB

0::Adult 18+	136790
0::Adult 18+\|\|1::Adult 18+	49273
0::Adult 18+\|\|1::Adult 18+\|\|2::Adult 18+	13893
0::Teen 12-17	7392
0::Adult 18+\|\|1::Adult 18+\|\|2::Adult 18+\|\|3::Adult 18+	4975
Other values (893)	27354

Length

Max length	1536
Median length	12
Mean length	20.2124359
Min length	11

Characters and Unicode

Total characters	4844456
Distinct characters	26
Distinct categories	7 ?
Distinct scripts	2 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	488 ?
Unique (%)	0.2%

Sample

1st row	0::Adult 18+\|\|1::Adult 18+\|\|2::Adult 18+\|\|3::Adult 18+\|\|4::Adult 18+
2nd row	0::Adult 18+\|\|1::Adult 18+\|\|2::Adult 18+\|\|3::Adult 18+
3rd row	0::Adult 18+\|\|1::Adult 18+\|\|2::Adult 18+\|\|3::Adult 18+\|\|4::Adult 18+
4th row	0::Adult 18+\|\|1::Adult 18+\|\|2::Adult 18+\|\|3::Adult 18+
5th row	0::Adult 18+\|\|1::Adult 18+\|\|2::Teen 12-17\|\|3::Adult 18+

Common Values

Value	Count	Frequency (%)
0::Adult 18+	136790	57.1%
0::Adult 18+\|\|1::Adult 18+	49273	20.6%
0::Adult 18+\|\|1::Adult 18+\|\|2::Adult 18+	13893	5.8%
0::Teen 12-17	7392	3.1%
0::Adult 18+\|\|1::Adult 18+\|\|2::Adult 18+\|\|3::Adult 18+	4975	2.1%
1::Adult 18+	3916	1.6%
0::Adult 18+\|\|1::Teen 12-17	1962	0.8%
0::Teen 12-17\|\|1::Adult 18+	1914	0.8%
0::Adult 18+\|\|1::Adult 18+\|\|2::Adult 18+\|\|3::Adult 18+\|\|4::Adult 18+	1736	0.7%
0::Teen 12-17\|\|1::Teen 12-17	1673	0.7%
Other values (888)	16153	6.7%

Length

Histogram of lengths of the category

Value	Count	Frequency (%)
18	223285	36.1%
0::adult	214544	34.7%
18+\|\|1::adult	73182	11.8%
18+\|\|2::adult	25269	4.1%
12-17	14623	2.4%
0::teen	13169	2.1%
18+\|\|3::adult	9699	1.6%
1::adult	5320	0.9%
18+\|\|4::adult	3776	0.6%
18+\|\|1::teen	3415	0.6%
Other values (307)	32132	5.2%

Most occurring characters

Value	Count	Frequency (%)
:	751137	15.5%
1	501343	10.3%
	378737	7.8%
d	353122	7.3%
l	353122	7.3%
8	348888	7.2%
A	348554	7.2%
u	348554	7.2%
t	348554	7.2%
+	348554	7.2%
Other values (16)	763891	15.8%

Most occurring categories

Value	Count	Frequency (%)
Lowercase Letter	1489333	30.7%
Decimal Number	1192814	24.6%
Other Punctuation	751137	15.5%
Math Symbol	623515	12.9%
Space Separator	378737	7.8%
Uppercase Letter	378737	7.8%
Dash Punctuation	30183	0.6%

Most frequent character per category

Decimal Number

Value	Count	Frequency (%)
1	501343	42.0%
8	348888	29.2%
0	238049	20.0%
2	57349	4.8%
7	26175	2.2%
3	12574	1.1%
4	5075	0.4%
5	2124	0.2%
6	1007	0.1%
9	230	< 0.1%

Lowercase Letter

Value	Count	Frequency (%)
d	353122	23.7%
l	353122	23.7%
u	348554	23.4%
t	348554	23.4%
e	51230	3.4%
n	25615	1.7%
h	4568	0.3%
i	4568	0.3%

Uppercase Letter

Value	Count	Frequency (%)
A	348554	92.0%
T	25615	6.8%
C	4568	1.2%

Math Symbol

Value	Count	Frequency (%)
+	348554	55.9%
\|	274961	44.1%

Other Punctuation

Value	Count	Frequency (%)
:	751137	100.0%

Space Separator

Value	Count	Frequency (%)
	378737	100.0%

Dash Punctuation

Value	Count	Frequency (%)
-	30183	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Common	2976386	61.4%
Latin	1868070	38.6%

Most frequent character per script

Common

Value	Count	Frequency (%)
:	751137	25.2%
1	501343	16.8%
	378737	12.7%
8	348888	11.7%
+	348554	11.7%
\|	274961	9.2%
0	238049	8.0%
2	57349	1.9%
-	30183	1.0%
7	26175	0.9%
Other values (5)	21010	0.7%

Latin

Value	Count	Frequency (%)
d	353122	18.9%
l	353122	18.9%
A	348554	18.7%
u	348554	18.7%
t	348554	18.7%
e	51230	2.7%
T	25615	1.4%
n	25615	1.4%
C	4568	0.2%
h	4568	0.2%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	4844456	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
:	751137	15.5%
1	501343	10.3%
	378737	7.8%
d	353122	7.3%
l	353122	7.3%
8	348888	7.2%
A	348554	7.2%
u	348554	7.2%
t	348554	7.2%
+	348554	7.2%
Other values (16)	763891	15.8%

participant_gender
Categorical

HIGH CARDINALITY

Distinct	873
Distinct (%)	0.4%
Missing	0
Missing (%)	0.0%
Memory size	3.7 MiB

0::Male	129858
0::Male\|\|1::Male	43530
0::Male\|\|1::Male\|\|2::Male	12383
0::Female\|\|1::Male	10602
0::Female	7791
Other values (868)	35513

Length

Max length	803
Median length	7
Mean length	12.92115222
Min length	6

Characters and Unicode

Total characters	3096903
Distinct characters	21
Distinct categories	6 ?
Distinct scripts	2 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	486 ?
Unique (%)	0.2%

Sample

1st row	0::Male\|\|1::Male\|\|3::Male\|\|4::Female
2nd row	0::Male
3rd row	0::Male\|\|1::Male\|\|2::Male\|\|3::Male\|\|4::Male
4th row	0::Female\|\|1::Male\|\|2::Male\|\|3::Male
5th row	0::Female\|\|1::Male\|\|2::Male\|\|3::Female

Common Values

Value	Count	Frequency (%)
0::Male	129858	54.2%
0::Male\|\|1::Male	43530	18.2%
0::Male\|\|1::Male\|\|2::Male	12383	5.2%
0::Female\|\|1::Male	10602	4.4%
0::Female	7791	3.3%
0::Male\|\|1::Female	5130	2.1%
0::Male\|\|1::Male\|\|2::Male\|\|3::Male	4333	1.8%
1::Male	4168	1.7%
0::Female\|\|1::Male\|\|2::Male	2062	0.9%
0::Male\|\|1::Female\|\|2::Male	1819	0.8%
Other values (863)	18001	7.5%

Length

Histogram of lengths of the category

Value	Count	Frequency (%)
0::male	129859	54.2%
0::male\|\|1::male	43530	18.2%
0::male\|\|1::male\|\|2::male	12383	5.2%
0::female\|\|1::male	10602	4.4%
0::female	7791	3.3%
0::male\|\|1::female	5130	2.1%
0::male\|\|1::male\|\|2::male\|\|3::male	4333	1.8%
1::male	4168	1.7%
0::female\|\|1::male\|\|2::male	2062	0.9%
0::male\|\|1::female\|\|2::male	1819	0.8%
Other values (863)	18001	7.5%

Most occurring characters

Value	Count	Frequency (%)
:	771466	24.9%
e	431799	13.9%
a	388626	12.5%
l	388626	12.5%
M	345453	11.2%
\|	295226	9.5%
0	232391	7.5%
1	99390	3.2%
m	43173	1.4%
F	43172	1.4%
Other values (11)	57581	1.9%

Most occurring categories

Value	Count	Frequency (%)
Lowercase Letter	1252225	40.4%
Other Punctuation	771467	24.9%
Decimal Number	389359	12.6%
Uppercase Letter	388625	12.5%
Math Symbol	295226	9.5%
Space Separator	1	< 0.1%

Most frequent character per category

Decimal Number

Value	Count	Frequency (%)
0	232391	59.7%
1	99390	25.5%
2	34472	8.9%
3	13564	3.5%
4	5322	1.4%
5	2187	0.6%
6	991	0.3%
7	529	0.1%
8	306	0.1%
9	207	0.1%

Lowercase Letter

Value	Count	Frequency (%)
e	431799	34.5%
a	388626	31.0%
l	388626	31.0%
m	43173	3.4%
f	1	< 0.1%

Other Punctuation

Value	Count	Frequency (%)
:	771466	> 99.9%
,	1	< 0.1%

Uppercase Letter

Value	Count	Frequency (%)
M	345453	88.9%
F	43172	11.1%

Math Symbol

Value	Count	Frequency (%)
\|	295226	100.0%

Space Separator

Value	Count	Frequency (%)
	1	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Latin	1640850	53.0%
Common	1456053	47.0%

Most frequent character per script

Common

Value	Count	Frequency (%)
:	771466	53.0%
\|	295226	20.3%
0	232391	16.0%
1	99390	6.8%
2	34472	2.4%
3	13564	0.9%
4	5322	0.4%
5	2187	0.2%
6	991	0.1%
7	529	< 0.1%
Other values (4)	515	< 0.1%

Latin

Value	Count	Frequency (%)
e	431799	26.3%
a	388626	23.7%
l	388626	23.7%
M	345453	21.1%
m	43173	2.6%
F	43172	2.6%
f	1	< 0.1%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	3096903	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
:	771466	24.9%
e	431799	13.9%
a	388626	12.5%
l	388626	12.5%
M	345453	11.2%
\|	295226	9.5%
0	232391	7.5%
1	99390	3.2%
m	43173	1.4%
F	43172	1.4%
Other values (11)	57581	1.9%

participant_relationship
Categorical

HIGH CARDINALITY

Distinct	284
Distinct (%)	0.1%
Missing	0
Missing (%)	0.0%
Memory size	3.7 MiB

1::Significant others - current or former	226554
1::Family	2573
1::Armed Robbery	1874
1::Armed Robbery\|\|2::Armed Robbery	1100
1::Friends	883
Other values (279)	6693

Length

Max length	366
Median length	41
Mean length	40.12421718
Min length	8

Characters and Unicode

Total characters	9616852
Distinct characters	51
Distinct categories	7 ?
Distinct scripts	2 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	124 ?
Unique (%)	0.1%

Sample

1st row	1::Significant others - current or former
2nd row	1::Significant others - current or former
3rd row	1::Significant others - current or former
4th row	1::Significant others - current or former
5th row	3::Family

Common Values

Value	Count	Frequency (%)
1::Significant others - current or former	226554	94.5%
1::Family	2573	1.1%
1::Armed Robbery	1874	0.8%
1::Armed Robbery\|\|2::Armed Robbery	1100	0.5%
1::Friends	883	0.4%
1::Aquaintance	719	0.3%
0::Significant others - current or former	483	0.2%
1::Armed Robbery\|\|2::Armed Robbery\|\|3::Armed Robbery	410	0.2%
1::Neighbor	389	0.2%
0::Armed Robbery	370	0.2%
Other values (274)	4322	1.8%

Length

Histogram of lengths of the category

Value	Count	Frequency (%)
	229345	16.4%
current	227374	16.3%
or	227374	16.3%
others	227374	16.3%
former	227359	16.3%
1::significant	226561	16.2%
robbery	4704	0.3%
1::armed	3521	0.3%
1::family	2573	0.2%
perp	1912	0.1%
Other values (216)	20167	1.4%

Most occurring characters

Value	Count	Frequency (%)
r	1384241	14.4%
	1158587	12.0%
e	706271	7.3%
o	699669	7.3%
i	694432	7.2%
n	692253	7.2%
t	686513	7.1%
:	488860	5.1%
c	457739	4.8%
f	454748	4.7%
Other values (41)	2193539	22.8%

Most occurring categories

Value	Count	Frequency (%)
Lowercase Letter	7222431	75.1%
Space Separator	1158587	12.0%
Other Punctuation	488860	5.1%
Uppercase Letter	263467	2.7%
Decimal Number	244477	2.5%
Dash Punctuation	229486	2.4%
Math Symbol	9544	0.1%

Most frequent character per category

Lowercase Letter

Value	Count	Frequency (%)
r	1384241	19.2%
e	706271	9.8%
o	699669	9.7%
i	694432	9.6%
n	692253	9.6%
t	686513	9.5%
c	457739	6.3%
f	454748	6.3%
m	242830	3.4%
a	236160	3.3%
Other values (13)	967575	13.4%

Uppercase Letter

Value	Count	Frequency (%)
S	227374	86.3%
A	8989	3.4%
R	8028	3.0%
F	4650	1.8%
N	2101	0.8%
V	1912	0.7%
K	1912	0.7%
P	1912	0.7%
I	1899	0.7%
H	1899	0.7%
Other values (4)	2791	1.1%

Decimal Number

Value	Count	Frequency (%)
1	236169	96.6%
2	3768	1.5%
0	2291	0.9%
3	1432	0.6%
4	520	0.2%
5	176	0.1%
6	63	< 0.1%
7	29	< 0.1%
8	18	< 0.1%
9	11	< 0.1%

Space Separator

Value	Count	Frequency (%)
	1158587	100.0%

Other Punctuation

Value	Count	Frequency (%)
:	488860	100.0%

Dash Punctuation

Value	Count	Frequency (%)
-	229486	100.0%

Math Symbol

Value	Count	Frequency (%)
\|	9544	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Latin	7485898	77.8%
Common	2130954	22.2%

Most frequent character per script

Latin

Value	Count	Frequency (%)
r	1384241	18.5%
e	706271	9.4%
o	699669	9.3%
i	694432	9.3%
n	692253	9.2%
t	686513	9.2%
c	457739	6.1%
f	454748	6.1%
m	242830	3.2%
a	236160	3.2%
Other values (27)	1231042	16.4%

Common

Value	Count	Frequency (%)
	1158587	54.4%
:	488860	22.9%
1	236169	11.1%
-	229486	10.8%
\|	9544	0.4%
2	3768	0.2%
0	2291	0.1%
3	1432	0.1%
4	520	< 0.1%
5	176	< 0.1%
Other values (4)	121	< 0.1%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	9616852	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
r	1384241	14.4%
	1158587	12.0%
e	706271	7.3%
o	699669	7.3%
i	694432	7.2%
n	692253	7.2%
t	686513	7.1%
:	488860	5.1%
c	457739	4.8%
f	454748	4.7%
Other values (41)	2193539	22.8%

participant_status
Categorical

HIGH CARDINALITY

Distinct	2150
Distinct (%)	0.9%
Missing	0
Missing (%)	0.0%
Memory size	3.7 MiB

0::Injured	69919
0::Unharmed, Arrested	25746
0::Killed	21216
0::Injured\|\|1::Unharmed	12680
0::Unharmed	11048
Other values (2145)	99068

Length

Max length	1500
Median length	1066
Mean length	22.64605281
Min length	8

Characters and Unicode

Total characters	5427738
Distinct characters	31
Distinct categories	6 ?
Distinct scripts	2 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	1181 ?
Unique (%)	0.5%

Sample

1st row	0::Arrested\|\|1::Injured\|\|2::Injured\|\|3::Injured\|\|4::Injured
2nd row	0::Killed\|\|1::Injured\|\|2::Injured\|\|3::Injured
3rd row	0::Injured, Unharmed, Arrested\|\|1::Unharmed, Arrested\|\|2::Killed\|\|3::Injured\|\|4::Injured
4th row	0::Killed\|\|1::Killed\|\|2::Killed\|\|3::Killed
5th row	0::Injured\|\|1::Injured\|\|2::Killed\|\|3::Killed

Common Values

Value	Count	Frequency (%)
0::Injured	69919	29.2%
0::Unharmed, Arrested	25746	10.7%
0::Killed	21216	8.9%
0::Injured\|\|1::Unharmed	12680	5.3%
0::Unharmed	11048	4.6%
0::Killed\|\|1::Unharmed, Arrested	7799	3.3%
0::Injured\|\|1::Unharmed, Arrested	7488	3.1%
0::Unharmed\|\|1::Unharmed	7042	2.9%
0::Injured\|\|1::Injured	6167	2.6%
0::Unharmed, Arrested\|\|1::Unharmed, Arrested	4658	1.9%
Other values (2140)	65914	27.5%

Length

Histogram of lengths of the category

Value	Count	Frequency (%)
0::injured	71721	21.8%
arrested	62404	19.0%
0::unharmed	46059	14.0%
0::injured\|\|1::unharmed	22189	6.7%
0::killed	21265	6.5%
0::killed\|\|1::unharmed	14657	4.5%
0::unharmed\|\|1::unharmed	9826	3.0%
arrested\|\|1::unharmed	8755	2.7%
arrested\|\|2::unharmed	7947	2.4%
0::injured\|\|1::injured	6473	2.0%
Other values (1177)	57636	17.5%

Most occurring characters

Value	Count	Frequency (%)
:	807299	14.9%
e	595548	11.0%
r	535070	9.9%
d	496215	9.1%
n	336404	6.2%
\|	331209	6.1%
0	236358	4.4%
U	190383	3.5%
h	190383	3.5%
a	190383	3.5%
Other values (21)	1518486	28.0%

Most occurring categories

Value	Count	Frequency (%)
Lowercase Letter	3206528	59.1%
Other Punctuation	896554	16.5%
Uppercase Letter	496215	9.1%
Decimal Number	407977	7.5%
Math Symbol	331209	6.1%
Space Separator	89255	1.6%

Most frequent character per category

Lowercase Letter

Value	Count	Frequency (%)
e	595548	18.6%
r	535070	16.7%
d	496215	15.5%
n	336404	10.5%
h	190383	5.9%
a	190383	5.9%
m	190383	5.9%
u	146021	4.6%
j	146021	4.6%
l	120956	3.8%
Other values (3)	259144	8.1%

Decimal Number

Value	Count	Frequency (%)
0	236358	57.9%
1	106989	26.2%
2	38041	9.3%
3	15281	3.7%
4	6156	1.5%
5	2578	0.6%
6	1220	0.3%
7	673	0.2%
8	397	0.1%
9	284	0.1%

Uppercase Letter

Value	Count	Frequency (%)
U	190383	38.4%
I	146021	29.4%
A	99333	20.0%
K	60478	12.2%

Other Punctuation

Value	Count	Frequency (%)
:	807299	90.0%
,	89255	10.0%

Math Symbol

Value	Count	Frequency (%)
\|	331209	100.0%

Space Separator

Value	Count	Frequency (%)
	89255	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Latin	3702743	68.2%
Common	1724995	31.8%

Most frequent character per script

Latin

Value	Count	Frequency (%)
e	595548	16.1%
r	535070	14.5%
d	496215	13.4%
n	336404	9.1%
U	190383	5.1%
h	190383	5.1%
a	190383	5.1%
m	190383	5.1%
u	146021	3.9%
j	146021	3.9%
Other values (7)	685932	18.5%

Common

Value	Count	Frequency (%)
:	807299	46.8%
\|	331209	19.2%
0	236358	13.7%
1	106989	6.2%
	89255	5.2%
,	89255	5.2%
2	38041	2.2%
3	15281	0.9%
4	6156	0.4%
5	2578	0.1%
Other values (4)	2574	0.1%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	5427738	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
:	807299	14.9%
e	595548	11.0%
r	535070	9.9%
d	496215	9.1%
n	336404	6.2%
\|	331209	6.1%
0	236358	4.4%
U	190383	3.5%
h	190383	3.5%
a	190383	3.5%
Other values (21)	1518486	28.0%

participant_type
Categorical

HIGH CARDINALITY

Distinct	259
Distinct (%)	0.1%
Missing	0
Missing (%)	0.0%
Memory size	3.7 MiB

0::Victim	83427
0::Victim\|\|1::Subject-Suspect	50579
0::Subject-Suspect	44914
0::Victim\|\|1::Subject-Suspect\|\|2::Subject-Suspect	10941
0::Victim\|\|1::Victim	9033
Other values (254)	40783

Length

Max length	1311
Median length	1236
Mean length	24.59072001
Min length	8

Characters and Unicode

Total characters	5893830
Distinct characters	25
Distinct categories	6 ?
Distinct scripts	2 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	96 ?
Unique (%)	< 0.1%

Sample

1st row	0::Victim\|\|1::Victim\|\|2::Victim\|\|3::Victim\|\|4::Subject-Suspect
2nd row	0::Victim\|\|1::Victim\|\|2::Victim\|\|3::Victim\|\|4::Subject-Suspect
3rd row	0::Subject-Suspect\|\|1::Subject-Suspect\|\|2::Victim\|\|3::Victim\|\|4::Victim
4th row	0::Victim\|\|1::Victim\|\|2::Victim\|\|3::Subject-Suspect
5th row	0::Victim\|\|1::Victim\|\|2::Victim\|\|3::Subject-Suspect

Common Values

Value	Count	Frequency (%)
0::Victim	83427	34.8%
0::Victim\|\|1::Subject-Suspect	50579	21.1%
0::Subject-Suspect	44914	18.7%
0::Victim\|\|1::Subject-Suspect\|\|2::Subject-Suspect	10941	4.6%
0::Victim\|\|1::Victim	9033	3.8%
0::Subject-Suspect\|\|1::Subject-Suspect	8922	3.7%
0::Victim\|\|1::Victim\|\|2::Subject-Suspect	6552	2.7%
0::Victim\|\|1::Subject-Suspect\|\|2::Subject-Suspect\|\|3::Subject-Suspect	3720	1.6%
0::Subject-Suspect\|\|1::Subject-Suspect\|\|2::Subject-Suspect	3040	1.3%
0::Victim\|\|1::Victim\|\|2::Subject-Suspect\|\|3::Subject-Suspect	2107	0.9%
Other values (249)	16442	6.9%

Length

Histogram of lengths of the category

Value	Count	Frequency (%)
0::victim	83427	34.8%
0::victim\|\|1::subject-suspect	50579	21.1%
0::subject-suspect	44914	18.7%
0::victim\|\|1::subject-suspect\|\|2::subject-suspect	10941	4.6%
0::victim\|\|1::victim	9033	3.8%
0::subject-suspect\|\|1::subject-suspect	8922	3.7%
0::victim\|\|1::victim\|\|2::subject-suspect	6552	2.7%
0::victim\|\|1::subject-suspect\|\|2::subject-suspect\|\|3::subject-suspect	3720	1.6%
0::subject-suspect\|\|1::subject-suspect\|\|2::subject-suspect	3040	1.3%
0::victim\|\|1::victim\|\|2::subject-suspect\|\|3::subject-suspect	2107	0.9%
Other values (249)	16442	6.9%

Most occurring characters

Value	Count	Frequency (%)
:	827562	14.0%
c	616449	10.5%
t	616449	10.5%
i	435846	7.4%
S	398526	6.8%
u	398526	6.8%
e	398526	6.8%
\|	351532	6.0%
0	239883	4.1%
V	217923	3.7%
Other values (15)	1392608	23.6%

Most occurring categories

Value	Count	Frequency (%)
Lowercase Letter	3480771	59.1%
Other Punctuation	827562	14.0%
Uppercase Letter	616449	10.5%
Decimal Number	418253	7.1%
Math Symbol	351532	6.0%
Dash Punctuation	199263	3.4%

Most frequent character per category

Lowercase Letter

Value	Count	Frequency (%)
c	616449	17.7%
t	616449	17.7%
i	435846	12.5%
u	398526	11.4%
e	398526	11.4%
m	217923	6.3%
p	199263	5.7%
s	199263	5.7%
j	199263	5.7%
b	199263	5.7%

Decimal Number

Value	Count	Frequency (%)
0	239883	57.4%
1	110860	26.5%
2	39613	9.5%
3	15996	3.8%
4	6478	1.5%
5	2721	0.7%
6	1287	0.3%
7	702	0.2%
8	417	0.1%
9	296	0.1%

Uppercase Letter

Value	Count	Frequency (%)
S	398526	64.6%
V	217923	35.4%

Other Punctuation

Value	Count	Frequency (%)
:	827562	100.0%

Math Symbol

Value	Count	Frequency (%)
\|	351532	100.0%

Dash Punctuation

Value	Count	Frequency (%)
-	199263	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Latin	4097220	69.5%
Common	1796610	30.5%

Most frequent character per script

Common

Value	Count	Frequency (%)
:	827562	46.1%
\|	351532	19.6%
0	239883	13.4%
-	199263	11.1%
1	110860	6.2%
2	39613	2.2%
3	15996	0.9%
4	6478	0.4%
5	2721	0.2%
6	1287	0.1%
Other values (3)	1415	0.1%

Latin

Value	Count	Frequency (%)
c	616449	15.0%
t	616449	15.0%
i	435846	10.6%
S	398526	9.7%
u	398526	9.7%
e	398526	9.7%
V	217923	5.3%
m	217923	5.3%
p	199263	4.9%
s	199263	4.9%
Other values (2)	398526	9.7%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	5893830	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
:	827562	14.0%
c	616449	10.5%
t	616449	10.5%
i	435846	7.4%
S	398526	6.8%
u	398526	6.8%
e	398526	6.8%
\|	351532	6.0%
0	239883	4.1%
V	217923	3.7%
Other values (15)	1392608	23.6%

state_house_district
Real number (ℝ_≥0)

HIGH CORRELATION

Distinct	276
Distinct (%)	0.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	55.44713173

Minimum	1
Maximum	901
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	3.7 MiB

Quantile statistics

Minimum	1
5-th percentile	5
Q1	27
median	55.44713173
Q3	77
95-th percentile	128
Maximum	901
Range	900
Interquartile range (IQR)	50

Descriptive statistics

Standard deviation	38.49714906
Coefficient of variation (CV)	0.6943037063
Kurtosis	21.37434483
Mean	55.44713173
Median Absolute Deviation (MAD)	25.55286827
Skewness	1.990581042
Sum	13289402.19
Variance	1482.030486
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
55.44713173	38772	16.2%
18	3476	1.5%
10	3411	1.4%
32	3218	1.3%
31	3192	1.3%
3	3064	1.3%
2	2941	1.2%
34	2897	1.2%
6	2870	1.2%
13	2762	1.2%
Other values (266)	173074	72.2%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
1	2056	0.9%
2	2941	1.2%
3	3064	1.3%
4	1928	0.8%
5	2603	1.1%
6	2870	1.2%
7	2059	0.9%
8	2475	1.0%
9	2492	1.0%
10	3411	1.4%

Value	Count	Frequency (%)
901	1	< 0.1%
814	1	< 0.1%
813	1	< 0.1%
811	1	< 0.1%
809	1	< 0.1%
808	1	< 0.1%
805	1	< 0.1%
804	1	< 0.1%
801	1	< 0.1%
729	2	< 0.1%

state_senate_district
Real number (ℝ_≥0)

HIGH CORRELATION

Distinct	69
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	20.47711028

Minimum	1
Maximum	94
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	3.7 MiB

Quantile statistics

Minimum	1
5-th percentile	3
Q1	10
median	20.47711028
Q3	29
95-th percentile	46
Maximum	94
Range	93
Interquartile range (IQR)	19

Descriptive statistics

Standard deviation	13.21168148
Coefficient of variation (CV)	0.645192671
Kurtosis	0.1855189135
Mean	20.47711028
Median Absolute Deviation (MAD)	9.477110282
Skewness	0.6863824434
Sum	4907892.361
Variance	174.5485275
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
20.47711028	32335	13.5%
5	10041	4.2%
9	7963	3.3%
3	7837	3.3%
4	7328	3.1%
2	6666	2.8%
15	5835	2.4%
6	5817	2.4%
19	5644	2.4%
14	5641	2.4%
Other values (59)	144570	60.3%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
1	5206	2.2%
2	6666	2.8%
3	7837	3.3%
4	7328	3.1%
5	10041	4.2%
6	5817	2.4%
7	4742	2.0%
8	3962	1.7%
9	7963	3.3%
10	4542	1.9%

Value	Count	Frequency (%)
94	1	< 0.1%
67	69	< 0.1%
66	33	< 0.1%
65	124	0.1%
64	20	< 0.1%
63	867	0.4%
62	350	0.1%
61	177	0.1%
60	204	0.1%
59	487	0.2%

Spearman's ρ

The Spearman's rank correlation coefficient (ρ) is a measure of monotonic correlation between two variables, and is therefore better in catching nonlinear monotonic correlations than Pearson's r. It's value lies between -1 and +1, -1 indicating total negative monotonic correlation, 0 indicating no monotonic correlation and 1 indicating total positive monotonic correlation.

To calculate ρ for two variables X and Y, one divides the covariance of the rank variables of X and Y by the product of their standard deviations.

Pearson's r

The Pearson's correlation coefficient (r) is a measure of linear correlation between two variables. It's value lies between -1 and +1, -1 indicating total negative linear correlation, 0 indicating no linear correlation and 1 indicating total positive linear correlation. Furthermore, r is invariant under separate changes in location and scale of the two variables, implying that for a linear function the angle to the x-axis does not affect r.

To calculate r for two variables X and Y, one divides the covariance of X and Y by the product of their standard deviations.

Kendall's τ

Similarly to Spearman's rank correlation coefficient, the Kendall rank correlation coefficient (τ) measures ordinal association between two variables. It's value lies between -1 and +1, -1 indicating total negative correlation, 0 indicating no correlation and 1 indicating total positive correlation.

To calculate τ for two variables X and Y, one determines the number of concordant and discordant pairs of observations. τ is given by the number of concordant pairs minus the discordant pairs divided by the total number of pairs.

Phik (φk)

Phik (φk) is a new and practical correlation coefficient that works consistently between categorical, ordinal and interval variables, captures non-linear dependency and reverts to the Pearson correlation coefficient in case of a bivariate normal input distribution. There is extensive documentation available here.

Count
Matrix

A simple visualization of nullity by column.

Nullity matrix is a data-dense display which lets you quickly visually pick out patterns in data completion.

First rows

	incident_id	date	state	city_or_county	address	n_killed	n_injured	congressional_district	gun_type	latitude	longitude	n_guns_involved	participant_age	participant_age_group	participant_gender	participant_relationship	participant_status	participant_type	state_house_district	state_senate_district
0	461105	2013-01-01	Pennsylvania	Mckeesport	1506 Versailles Avenue and Coursin Street	1.123064	4.000000	14.0	0::Unknown	40.3467	40.3467	1.372442	0::20	0::Adult 18+\|\|1::Adult 18+\|\|2::Adult 18+\|\|3::Adult 18+\|\|4::Adult 18+	0::Male\|\|1::Male\|\|3::Male\|\|4::Female	1::Significant others - current or former	0::Arrested\|\|1::Injured\|\|2::Injured\|\|3::Injured\|\|4::Injured	0::Victim\|\|1::Victim\|\|2::Victim\|\|3::Victim\|\|4::Subject-Suspect	55.447132	20.47711
1	460726	2013-01-01	California	Hawthorne	13500 block of Cerise Avenue	1.000000	3.000000	43.0	0::Unknown	33.909	33.909	1.372442	0::20	0::Adult 18+\|\|1::Adult 18+\|\|2::Adult 18+\|\|3::Adult 18+	0::Male	1::Significant others - current or former	0::Killed\|\|1::Injured\|\|2::Injured\|\|3::Injured	0::Victim\|\|1::Victim\|\|2::Victim\|\|3::Victim\|\|4::Subject-Suspect	62.000000	35.00000
2	478855	2013-01-01	Ohio	Lorain	1776 East 28th Street	1.000000	3.000000	9.0	0::Unknown\|\|1::Unknown	41.4455	41.4455	2.000000	0::25\|\|1::31\|\|2::33\|\|3::34\|\|4::33	0::Adult 18+\|\|1::Adult 18+\|\|2::Adult 18+\|\|3::Adult 18+\|\|4::Adult 18+	0::Male\|\|1::Male\|\|2::Male\|\|3::Male\|\|4::Male	1::Significant others - current or former	0::Injured, Unharmed, Arrested\|\|1::Unharmed, Arrested\|\|2::Killed\|\|3::Injured\|\|4::Injured	0::Subject-Suspect\|\|1::Subject-Suspect\|\|2::Victim\|\|3::Victim\|\|4::Victim	56.000000	13.00000
3	478925	2013-05-01	Colorado	Aurora	16000 block of East Ithaca Place	4.000000	1.218253	6.0	0::Unknown	39.6518	39.6518	1.372442	0::29\|\|1::33\|\|2::56\|\|3::33	0::Adult 18+\|\|1::Adult 18+\|\|2::Adult 18+\|\|3::Adult 18+	0::Female\|\|1::Male\|\|2::Male\|\|3::Male	1::Significant others - current or former	0::Killed\|\|1::Killed\|\|2::Killed\|\|3::Killed	0::Victim\|\|1::Victim\|\|2::Victim\|\|3::Subject-Suspect	40.000000	28.00000
4	478959	2013-07-01	North Carolina	Greensboro	307 Mourning Dove Terrace	2.000000	2.000000	6.0	0::Handgun\|\|1::Handgun	36.114	36.114	2.000000	0::18\|\|1::46\|\|2::14\|\|3::47	0::Adult 18+\|\|1::Adult 18+\|\|2::Teen 12-17\|\|3::Adult 18+	0::Female\|\|1::Male\|\|2::Male\|\|3::Female	3::Family	0::Injured\|\|1::Injured\|\|2::Killed\|\|3::Killed	0::Victim\|\|1::Victim\|\|2::Victim\|\|3::Subject-Suspect	62.000000	27.00000
5	478948	2013-07-01	Oklahoma	Tulsa	6000 block of South Owasso	4.000000	1.218253	1.0	0::Unknown	36.2405	36.2405	1.372442	0::23\|\|1::23\|\|2::33\|\|3::55	0::Adult 18+\|\|1::Adult 18+\|\|2::Adult 18+\|\|3::Adult 18+\|\|4::Adult 18+\|\|5::Adult 18+	0::Female\|\|1::Female\|\|2::Female\|\|3::Female\|\|4::Male\|\|5::Male	1::Significant others - current or former	0::Killed\|\|1::Killed\|\|2::Killed\|\|3::Killed\|\|4::Unharmed, Arrested\|\|5::Unharmed, Arrested	0::Victim\|\|1::Victim\|\|2::Victim\|\|3::Victim\|\|4::Subject-Suspect\|\|5::Subject-Suspect	72.000000	11.00000
6	479363	2013-01-19	New Mexico	Albuquerque	2806 Long Lane	5.000000	1.218253	1.0	0::22 LR\|\|1::223 Rem [AR-15]	34.9791	34.9791	2.000000	0::51\|\|1::40\|\|2::9\|\|3::5\|\|4::2\|\|5::15	0::Adult 18+\|\|1::Adult 18+\|\|2::Child 0-11\|\|3::Child 0-11\|\|4::Child 0-11\|\|5::Teen 12-17	0::Male\|\|1::Female\|\|2::Male\|\|3::Female\|\|4::Female\|\|5::Male	5::Family	0::Killed\|\|1::Killed\|\|2::Killed\|\|3::Killed\|\|4::Killed\|\|5::Unharmed, Arrested	0::Victim\|\|1::Victim\|\|2::Victim\|\|3::Victim\|\|4::Victim\|\|5::Subject-Suspect	10.000000	14.00000
7	479374	2013-01-21	Louisiana	New Orleans	LaSalle Street and Martin Luther King Jr. Boulevard	1.123064	5.000000	2.0	0::Unknown	29.9435	29.9435	1.372442	0::24	0::Adult 18+	0::Male\|\|1::Male\|\|2::Male\|\|3::Male\|\|4::Male	1::Significant others - current or former	0::Injured\|\|1::Injured\|\|2::Injured\|\|3::Injured\|\|4::Injured	0::Victim\|\|1::Victim\|\|2::Victim\|\|3::Victim\|\|4::Victim\|\|5::Subject-Suspect	93.000000	5.00000
8	479389	2013-01-21	California	Brentwood	1100 block of Breton Drive	1.123064	4.000000	9.0	0::Unknown	37.9656	37.9656	1.372442	0::24	0::Teen 12-17\|\|1::Teen 12-17\|\|2::Teen 12-17\|\|4::Adult 18+	0::Male\|\|1::Male\|\|2::Male\|\|3::Male\|\|4::Male	1::Significant others - current or former	0::Injured\|\|1::Injured\|\|2::Injured\|\|3::Injured\|\|4::Unharmed	0::Victim\|\|1::Victim\|\|2::Victim\|\|3::Victim\|\|4::Subject-Suspect	11.000000	7.00000
9	492151	2013-01-23	Maryland	Baltimore	1500 block of W. Fayette St.	1.000000	6.000000	7.0	0::Unknown	39.2899	39.2899	1.372442	0::15	0::Teen 12-17\|\|1::Adult 18+\|\|2::Adult 18+\|\|3::Adult 18+\|\|4::Adult 18+\|\|5::Adult 18+\|\|6::Adult 18+	0::Male	1::Significant others - current or former	0::Killed\|\|1::Injured\|\|2::Injured\|\|3::Injured\|\|4::Injured\|\|5::Injured\|\|6::Injured	0::Victim\|\|1::Victim\|\|2::Victim\|\|3::Victim\|\|4::Victim\|\|5::Victim\|\|6::Victim	55.447132	44.00000

Last rows

	incident_id	date	state	city_or_county	address	n_killed	n_injured	congressional_district	gun_type	latitude	longitude	n_guns_involved	participant_age	participant_age_group	participant_gender	participant_relationship	participant_status	participant_type	state_house_district	state_senate_district
239667	1082234	2018-03-31	Tennessee	Memphis	2900 block of Wingate	1.123064	1.000000	9.000000	0::Unknown	35.2045	35.2045	1.0	0::69\|\|1::35	0::Adult 18+\|\|1::Adult 18+	0::Male\|\|1::Female	1::Significant others - current or former	0::Injured\|\|1::Arrested	0::Victim\|\|1::Subject-Suspect	90.000000	30.00000
239668	1081742	2018-03-31	Michigan	Detroit	I-96	1.123064	1.000000	8.016084	0::Unknown	0.0	0.0	1.0	0::24	0::Adult 18+	0::Male	1::Significant others - current or former	0::Injured	0::Victim	55.447132	20.47711
239669	1082990	2018-03-31	Wisconsin	Madison	Hayes Rd	1.123064	1.218253	8.016084	0::45 Auto	0.0	0.0	1.0	0::24	0::Adult 18+	0::Male	1::Significant others - current or former	0::Injured	0::Victim	55.447132	20.47711
239670	1081752	2018-03-31	Illinois	Chicago	1 block of N Paulina St	1.123064	1.000000	8.016084	0::Unknown	0.0	0.0	1.0	0::36	0::Adult 18+\|\|1::Adult 18+	0::Male\|\|1::Male	1::Significant others - current or former	0::Injured\|\|1::Unharmed	0::Victim\|\|1::Subject-Suspect	55.447132	20.47711
239671	1082061	2018-03-31	Washington	Spokane (Spokane Valley)	12600 block of N Willow Crest Ln	1.123064	1.218253	5.000000	0::Unknown	47.6638	47.6638	1.0	0::48	0::Adult 18+	0::Male	1::Significant others - current or former	0::Unharmed, Arrested	0::Subject-Suspect	4.000000	4.00000
239672	1083142	2018-03-31	Louisiana	Rayne	North Riceland Road and Highway 90	1.123064	1.218253	8.016084	0::Unknown	0.0	0.0	1.0	0::25	0::Adult 18+	0::Female	1::Significant others - current or former	0::Unharmed, Arrested	0::Subject-Suspect	55.447132	20.47711
239673	1083139	2018-03-31	Louisiana	Natchitoches	247 Keyser Ave	1.000000	1.218253	4.000000	0::Unknown	31.7537	31.7537	1.0	1::21	0::Adult 18+\|\|1::Adult 18+	0::Male\|\|1::Male	1::Significant others - current or former	0::Killed\|\|1::Unharmed, Arrested	0::Victim\|\|1::Subject-Suspect	23.000000	31.00000
239674	1083151	2018-03-31	Louisiana	Gretna	1300 block of Cook Street	1.123064	1.000000	2.000000	0::Unknown	29.9239	29.9239	1.0	0::21	0::Adult 18+	0::Male	1::Significant others - current or former	0::Injured	0::Victim	85.000000	7.00000
239675	1082514	2018-03-31	Texas	Houston	12630 Ashford Point Dr	1.000000	1.218253	9.000000	0::Unknown	29.7201	29.7201	1.0	0::42	0::Adult 18+	0::Male	1::Significant others - current or former	0::Killed	0::Victim	149.000000	17.00000
239676	1081940	2018-03-31	Maine	Norridgewock	434 Skowhegan Rd	2.000000	1.218253	2.000000	0::Handgun\|\|1::Shotgun	44.7293	44.7293	2.0	0::58\|\|1::62	0::Adult 18+\|\|1::Adult 18+	0::Female\|\|1::Male	1::Significant others - current or former	0::Killed\|\|1::Killed	0::Victim\|\|1::Subject-Suspect	111.000000	3.00000

Overview

Variables

Common Values

Length

Most occurring characters

Most occurring categories

Most frequent character per category

Lowercase Letter

Uppercase Letter

Space Separator

Most occurring scripts

Most frequent character per script

Latin

Common

Most occurring blocks

Most frequent character per block

ASCII

Common Values

Length

Most occurring characters

Most occurring categories

Most frequent character per category

Lowercase Letter

Uppercase Letter

Other Punctuation

Space Separator

Close Punctuation

Open Punctuation

Dash Punctuation

Most occurring scripts

Most frequent character per script

Latin

Common

Most occurring blocks

Most frequent character per block

ASCII

None

Common Values

Length

Most occurring characters

Most occurring categories

Most frequent character per category

Lowercase Letter

Uppercase Letter

Decimal Number

Other Punctuation

Format

Space Separator

Dash Punctuation

Open Punctuation

Close Punctuation

Other Number

Final Punctuation

Modifier Letter

Line Separator

Modifier Symbol

Initial Punctuation

Most occurring scripts

Most frequent character per script

Latin

Common

Most occurring blocks

Most frequent character per block

ASCII

None

Punctuation

Modifier Letters

Common Values

Length

Most occurring characters

Most occurring categories

Most frequent character per category

Lowercase Letter

Decimal Number

Uppercase Letter

Other Punctuation

Math Symbol

Space Separator

Dash Punctuation

Open Punctuation